-- [(${table_value})]-初始化

CREATE TABLE [(${table_name})]
(
   SEQUENCE_NO NUMBER(18)	not null constraint [(${table_name})]_PK 	primary key,
[# th:each="vo:${lists}"]
   [(${vo.fieldName})] [(${vo.type})]  [# th:if="${vo.flag}"] not null [/] ,
[/]

);
-- 建立索引
CREATE unique INDEX [(${table_name})]_INDEXID ON [(${table_name})]([(${unique_id})]);

-- 创建序列
CREATE SEQUENCE  SEQ_[(${table_name})]  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 10 ORDER  NOCYCLE;

comment on table [(${table_name})] is '[(${table_value})]';
comment on column [(${table_name})].SEQUENCE_NO is '顺序号';

[# th:each="vo:${lists}"]
comment on column [(${table_name})].[(${vo.fieldName})] is '[(${vo.value})]';
[/]

commit;